/*
*
* UserBaseExample.java
* @author may
* @date 2021-04-23 14:23:00
*/
package com.steel.yfmall.cloud.assistant.po.user;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class UserBaseExample {
    /**
     * m_user_base
     */
    protected String orderByClause;

    /**
     * m_user_base
     */
    protected boolean distinct;

    /**
     * m_user_base
     */
    protected List<Criteria> oredCriteria;

    private Integer limit;

    private Integer offset;

    private String groupByClause;

    private String selectFields;

    /**
     * 构造查询条件:m_user_base
     * @Title: UserBaseExample
     * @Description: ( )
     * @return 返回类型 null
     * @date 2021-04-23 14:23:00
     */
    public UserBaseExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    /**
     * 设置排序字段:m_user_base
     * @Title: setOrderByClause
     * @Description: ( 设置排序字段 )
     * @param 参数说明 类型:String	名称:orderByClause 排序字段
     * @return 返回类型 null
     * @date 2021-04-23 14:23:00
     */
    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    /**
     * 获取排序字段:m_user_base
     * @Title: getOrderByClause
     * @Description: ( 获取排序字段 )
     * @return 返回类型 java.lang.String
     * @date 2021-04-23 14:23:00
     */
    public String getOrderByClause() {
        return orderByClause;
    }

    /**
     * 设置过滤重复数据:m_user_base
     * @Title: setDistinct
     * @Description: ( 设置过滤重复数据 )
     * @param 参数说明 类型:boolean	名称:distinct 是否过滤重复数据
     * @return 返回类型 null
     * @date 2021-04-23 14:23:00
     */
    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    /**
     * 是否过滤重复数据:m_user_base
     * @Title: isDistinct
     * @Description: ( 是否过滤重复数据 )
     * @return 返回类型 boolean
     * @date 2021-04-23 14:23:00
     */
    public boolean isDistinct() {
        return distinct;
    }

    /**
     * 获取当前的查询条件实例:m_user_base
     * @Title: getOredCriteria
     * @Description: ( 获取当前的查询条件实例 )
     * @return 返回类型 java.util.List<Criteria>
     * @date 2021-04-23 14:23:00
     */
    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    /**
     *:m_user_base
     * @Title: or
     * @Description: ( )
     *
     * @param 参数说明 类型:Criteria	名称:criteria 过滤条件实例
     * @return 返回类型 null
     * @date 2021-04-23 14:23:00
     */
    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    /**
     *:m_user_base
     * @Title: or
     * @Description: ( )
     *
     * @return 返回类型 Criteria
     * @date 2021-04-23 14:23:00
     */
    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    /**
     * 创建一个查询条件:m_user_base
     * @Title: createCriteria
     * @Description: ( 创建一个查询条件 )
     * @return 返回类型 Criteria
     * @date 2021-04-23 14:23:00
     */
    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    /**
     * 内部构建查询条件对象:m_user_base
     * @Title: createCriteriaInternal
     * @Description: ( 内部构建查询条件对象 )
     * @return 返回类型 Criteria
     * @date 2021-04-23 14:23:00
     */
    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    /**
     * 清除查询条件:m_user_base
     * @Title: clear
     * @Description: ( 清除查询条件 )
     * @return 返回类型 null
     * @date 2021-04-23 14:23:00
     */
    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    public void limit(Integer offset, Integer limit) {
        this.offset = offset;
        this.limit = limit;
    }

    public Integer getLimit() {
        return limit;
    }

    public void setOffset(Integer offset) {
        this.offset = offset;
    }

    public Integer getOffset() {
        return offset;
    }

    public void setGroupByClause(String groupByClause) {
        this.groupByClause = groupByClause;
    }

    public String getGroupByClause() {
        return groupByClause;
    }

    public void setSelectFields(String selectFields) {
        this.selectFields = selectFields;
    }

    public String getSelectFields() {
        return selectFields;
    }

    /**
     * @title m_user_base表的实体类
     * @description m_user_base
     * @version 1.0
     * @author may
     * @date 2021-04-23 14:23:00
     */
    protected abstract static class GeneratedCriteria implements java.io.Serializable {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Integer value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Integer value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Integer value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Integer value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Integer value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Integer> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Integer> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Integer value1, Integer value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Integer value1, Integer value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andUserNameIsNull() {
            addCriterion("user_name is null");
            return (Criteria) this;
        }

        public Criteria andUserNameIsNotNull() {
            addCriterion("user_name is not null");
            return (Criteria) this;
        }

        public Criteria andUserNameEqualTo(String value) {
            addCriterion("user_name =", value, "userName");
            return (Criteria) this;
        }

        public Criteria andUserNameNotEqualTo(String value) {
            addCriterion("user_name <>", value, "userName");
            return (Criteria) this;
        }

        public Criteria andUserNameGreaterThan(String value) {
            addCriterion("user_name >", value, "userName");
            return (Criteria) this;
        }

        public Criteria andUserNameGreaterThanOrEqualTo(String value) {
            addCriterion("user_name >=", value, "userName");
            return (Criteria) this;
        }

        public Criteria andUserNameLessThan(String value) {
            addCriterion("user_name <", value, "userName");
            return (Criteria) this;
        }

        public Criteria andUserNameLessThanOrEqualTo(String value) {
            addCriterion("user_name <=", value, "userName");
            return (Criteria) this;
        }

        public Criteria andUserNameLike(String value) {
            addCriterion("user_name like", value, "userName");
            return (Criteria) this;
        }

        public Criteria andUserNameNotLike(String value) {
            addCriterion("user_name not like", value, "userName");
            return (Criteria) this;
        }

        public Criteria andUserNameIn(List<String> values) {
            addCriterion("user_name in", values, "userName");
            return (Criteria) this;
        }

        public Criteria andUserNameNotIn(List<String> values) {
            addCriterion("user_name not in", values, "userName");
            return (Criteria) this;
        }

        public Criteria andUserNameBetween(String value1, String value2) {
            addCriterion("user_name between", value1, value2, "userName");
            return (Criteria) this;
        }

        public Criteria andUserNameNotBetween(String value1, String value2) {
            addCriterion("user_name not between", value1, value2, "userName");
            return (Criteria) this;
        }

        public Criteria andPasswordIsNull() {
            addCriterion("password is null");
            return (Criteria) this;
        }

        public Criteria andPasswordIsNotNull() {
            addCriterion("password is not null");
            return (Criteria) this;
        }

        public Criteria andPasswordEqualTo(String value) {
            addCriterion("password =", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordNotEqualTo(String value) {
            addCriterion("password <>", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordGreaterThan(String value) {
            addCriterion("password >", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordGreaterThanOrEqualTo(String value) {
            addCriterion("password >=", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordLessThan(String value) {
            addCriterion("password <", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordLessThanOrEqualTo(String value) {
            addCriterion("password <=", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordLike(String value) {
            addCriterion("password like", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordNotLike(String value) {
            addCriterion("password not like", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordIn(List<String> values) {
            addCriterion("password in", values, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordNotIn(List<String> values) {
            addCriterion("password not in", values, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordBetween(String value1, String value2) {
            addCriterion("password between", value1, value2, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordNotBetween(String value1, String value2) {
            addCriterion("password not between", value1, value2, "password");
            return (Criteria) this;
        }

        public Criteria andNickNameIsNull() {
            addCriterion("nick_name is null");
            return (Criteria) this;
        }

        public Criteria andNickNameIsNotNull() {
            addCriterion("nick_name is not null");
            return (Criteria) this;
        }

        public Criteria andNickNameEqualTo(String value) {
            addCriterion("nick_name =", value, "nickName");
            return (Criteria) this;
        }

        public Criteria andNickNameNotEqualTo(String value) {
            addCriterion("nick_name <>", value, "nickName");
            return (Criteria) this;
        }

        public Criteria andNickNameGreaterThan(String value) {
            addCriterion("nick_name >", value, "nickName");
            return (Criteria) this;
        }

        public Criteria andNickNameGreaterThanOrEqualTo(String value) {
            addCriterion("nick_name >=", value, "nickName");
            return (Criteria) this;
        }

        public Criteria andNickNameLessThan(String value) {
            addCriterion("nick_name <", value, "nickName");
            return (Criteria) this;
        }

        public Criteria andNickNameLessThanOrEqualTo(String value) {
            addCriterion("nick_name <=", value, "nickName");
            return (Criteria) this;
        }

        public Criteria andNickNameLike(String value) {
            addCriterion("nick_name like", value, "nickName");
            return (Criteria) this;
        }

        public Criteria andNickNameNotLike(String value) {
            addCriterion("nick_name not like", value, "nickName");
            return (Criteria) this;
        }

        public Criteria andNickNameIn(List<String> values) {
            addCriterion("nick_name in", values, "nickName");
            return (Criteria) this;
        }

        public Criteria andNickNameNotIn(List<String> values) {
            addCriterion("nick_name not in", values, "nickName");
            return (Criteria) this;
        }

        public Criteria andNickNameBetween(String value1, String value2) {
            addCriterion("nick_name between", value1, value2, "nickName");
            return (Criteria) this;
        }

        public Criteria andNickNameNotBetween(String value1, String value2) {
            addCriterion("nick_name not between", value1, value2, "nickName");
            return (Criteria) this;
        }

        public Criteria andOtherUserCodeIsNull() {
            addCriterion("other_user_code is null");
            return (Criteria) this;
        }

        public Criteria andOtherUserCodeIsNotNull() {
            addCriterion("other_user_code is not null");
            return (Criteria) this;
        }

        public Criteria andOtherUserCodeEqualTo(String value) {
            addCriterion("other_user_code =", value, "otherUserCode");
            return (Criteria) this;
        }

        public Criteria andOtherUserCodeNotEqualTo(String value) {
            addCriterion("other_user_code <>", value, "otherUserCode");
            return (Criteria) this;
        }

        public Criteria andOtherUserCodeGreaterThan(String value) {
            addCriterion("other_user_code >", value, "otherUserCode");
            return (Criteria) this;
        }

        public Criteria andOtherUserCodeGreaterThanOrEqualTo(String value) {
            addCriterion("other_user_code >=", value, "otherUserCode");
            return (Criteria) this;
        }

        public Criteria andOtherUserCodeLessThan(String value) {
            addCriterion("other_user_code <", value, "otherUserCode");
            return (Criteria) this;
        }

        public Criteria andOtherUserCodeLessThanOrEqualTo(String value) {
            addCriterion("other_user_code <=", value, "otherUserCode");
            return (Criteria) this;
        }

        public Criteria andOtherUserCodeLike(String value) {
            addCriterion("other_user_code like", value, "otherUserCode");
            return (Criteria) this;
        }

        public Criteria andOtherUserCodeNotLike(String value) {
            addCriterion("other_user_code not like", value, "otherUserCode");
            return (Criteria) this;
        }

        public Criteria andOtherUserCodeIn(List<String> values) {
            addCriterion("other_user_code in", values, "otherUserCode");
            return (Criteria) this;
        }

        public Criteria andOtherUserCodeNotIn(List<String> values) {
            addCriterion("other_user_code not in", values, "otherUserCode");
            return (Criteria) this;
        }

        public Criteria andOtherUserCodeBetween(String value1, String value2) {
            addCriterion("other_user_code between", value1, value2, "otherUserCode");
            return (Criteria) this;
        }

        public Criteria andOtherUserCodeNotBetween(String value1, String value2) {
            addCriterion("other_user_code not between", value1, value2, "otherUserCode");
            return (Criteria) this;
        }

        public Criteria andCompanyCodeIsNull() {
            addCriterion("company_code is null");
            return (Criteria) this;
        }

        public Criteria andCompanyCodeIsNotNull() {
            addCriterion("company_code is not null");
            return (Criteria) this;
        }

        public Criteria andCompanyCodeEqualTo(String value) {
            addCriterion("company_code =", value, "companyCode");
            return (Criteria) this;
        }

        public Criteria andCompanyCodeNotEqualTo(String value) {
            addCriterion("company_code <>", value, "companyCode");
            return (Criteria) this;
        }

        public Criteria andCompanyCodeGreaterThan(String value) {
            addCriterion("company_code >", value, "companyCode");
            return (Criteria) this;
        }

        public Criteria andCompanyCodeGreaterThanOrEqualTo(String value) {
            addCriterion("company_code >=", value, "companyCode");
            return (Criteria) this;
        }

        public Criteria andCompanyCodeLessThan(String value) {
            addCriterion("company_code <", value, "companyCode");
            return (Criteria) this;
        }

        public Criteria andCompanyCodeLessThanOrEqualTo(String value) {
            addCriterion("company_code <=", value, "companyCode");
            return (Criteria) this;
        }

        public Criteria andCompanyCodeLike(String value) {
            addCriterion("company_code like", value, "companyCode");
            return (Criteria) this;
        }

        public Criteria andCompanyCodeNotLike(String value) {
            addCriterion("company_code not like", value, "companyCode");
            return (Criteria) this;
        }

        public Criteria andCompanyCodeIn(List<String> values) {
            addCriterion("company_code in", values, "companyCode");
            return (Criteria) this;
        }

        public Criteria andCompanyCodeNotIn(List<String> values) {
            addCriterion("company_code not in", values, "companyCode");
            return (Criteria) this;
        }

        public Criteria andCompanyCodeBetween(String value1, String value2) {
            addCriterion("company_code between", value1, value2, "companyCode");
            return (Criteria) this;
        }

        public Criteria andCompanyCodeNotBetween(String value1, String value2) {
            addCriterion("company_code not between", value1, value2, "companyCode");
            return (Criteria) this;
        }

        public Criteria andSaltIsNull() {
            addCriterion("salt is null");
            return (Criteria) this;
        }

        public Criteria andSaltIsNotNull() {
            addCriterion("salt is not null");
            return (Criteria) this;
        }

        public Criteria andSaltEqualTo(String value) {
            addCriterion("salt =", value, "salt");
            return (Criteria) this;
        }

        public Criteria andSaltNotEqualTo(String value) {
            addCriterion("salt <>", value, "salt");
            return (Criteria) this;
        }

        public Criteria andSaltGreaterThan(String value) {
            addCriterion("salt >", value, "salt");
            return (Criteria) this;
        }

        public Criteria andSaltGreaterThanOrEqualTo(String value) {
            addCriterion("salt >=", value, "salt");
            return (Criteria) this;
        }

        public Criteria andSaltLessThan(String value) {
            addCriterion("salt <", value, "salt");
            return (Criteria) this;
        }

        public Criteria andSaltLessThanOrEqualTo(String value) {
            addCriterion("salt <=", value, "salt");
            return (Criteria) this;
        }

        public Criteria andSaltLike(String value) {
            addCriterion("salt like", value, "salt");
            return (Criteria) this;
        }

        public Criteria andSaltNotLike(String value) {
            addCriterion("salt not like", value, "salt");
            return (Criteria) this;
        }

        public Criteria andSaltIn(List<String> values) {
            addCriterion("salt in", values, "salt");
            return (Criteria) this;
        }

        public Criteria andSaltNotIn(List<String> values) {
            addCriterion("salt not in", values, "salt");
            return (Criteria) this;
        }

        public Criteria andSaltBetween(String value1, String value2) {
            addCriterion("salt between", value1, value2, "salt");
            return (Criteria) this;
        }

        public Criteria andSaltNotBetween(String value1, String value2) {
            addCriterion("salt not between", value1, value2, "salt");
            return (Criteria) this;
        }

        public Criteria andMobileIsNull() {
            addCriterion("mobile is null");
            return (Criteria) this;
        }

        public Criteria andMobileIsNotNull() {
            addCriterion("mobile is not null");
            return (Criteria) this;
        }

        public Criteria andMobileEqualTo(String value) {
            addCriterion("mobile =", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileNotEqualTo(String value) {
            addCriterion("mobile <>", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileGreaterThan(String value) {
            addCriterion("mobile >", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileGreaterThanOrEqualTo(String value) {
            addCriterion("mobile >=", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileLessThan(String value) {
            addCriterion("mobile <", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileLessThanOrEqualTo(String value) {
            addCriterion("mobile <=", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileLike(String value) {
            addCriterion("mobile like", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileNotLike(String value) {
            addCriterion("mobile not like", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileIn(List<String> values) {
            addCriterion("mobile in", values, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileNotIn(List<String> values) {
            addCriterion("mobile not in", values, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileBetween(String value1, String value2) {
            addCriterion("mobile between", value1, value2, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileNotBetween(String value1, String value2) {
            addCriterion("mobile not between", value1, value2, "mobile");
            return (Criteria) this;
        }

        public Criteria andContactDetailsIsNull() {
            addCriterion("contact_details is null");
            return (Criteria) this;
        }

        public Criteria andContactDetailsIsNotNull() {
            addCriterion("contact_details is not null");
            return (Criteria) this;
        }

        public Criteria andContactDetailsEqualTo(String value) {
            addCriterion("contact_details =", value, "contactDetails");
            return (Criteria) this;
        }

        public Criteria andContactDetailsNotEqualTo(String value) {
            addCriterion("contact_details <>", value, "contactDetails");
            return (Criteria) this;
        }

        public Criteria andContactDetailsGreaterThan(String value) {
            addCriterion("contact_details >", value, "contactDetails");
            return (Criteria) this;
        }

        public Criteria andContactDetailsGreaterThanOrEqualTo(String value) {
            addCriterion("contact_details >=", value, "contactDetails");
            return (Criteria) this;
        }

        public Criteria andContactDetailsLessThan(String value) {
            addCriterion("contact_details <", value, "contactDetails");
            return (Criteria) this;
        }

        public Criteria andContactDetailsLessThanOrEqualTo(String value) {
            addCriterion("contact_details <=", value, "contactDetails");
            return (Criteria) this;
        }

        public Criteria andContactDetailsLike(String value) {
            addCriterion("contact_details like", value, "contactDetails");
            return (Criteria) this;
        }

        public Criteria andContactDetailsNotLike(String value) {
            addCriterion("contact_details not like", value, "contactDetails");
            return (Criteria) this;
        }

        public Criteria andContactDetailsIn(List<String> values) {
            addCriterion("contact_details in", values, "contactDetails");
            return (Criteria) this;
        }

        public Criteria andContactDetailsNotIn(List<String> values) {
            addCriterion("contact_details not in", values, "contactDetails");
            return (Criteria) this;
        }

        public Criteria andContactDetailsBetween(String value1, String value2) {
            addCriterion("contact_details between", value1, value2, "contactDetails");
            return (Criteria) this;
        }

        public Criteria andContactDetailsNotBetween(String value1, String value2) {
            addCriterion("contact_details not between", value1, value2, "contactDetails");
            return (Criteria) this;
        }

        public Criteria andAddressIsNull() {
            addCriterion("address is null");
            return (Criteria) this;
        }

        public Criteria andAddressIsNotNull() {
            addCriterion("address is not null");
            return (Criteria) this;
        }

        public Criteria andAddressEqualTo(String value) {
            addCriterion("address =", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotEqualTo(String value) {
            addCriterion("address <>", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressGreaterThan(String value) {
            addCriterion("address >", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressGreaterThanOrEqualTo(String value) {
            addCriterion("address >=", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLessThan(String value) {
            addCriterion("address <", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLessThanOrEqualTo(String value) {
            addCriterion("address <=", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLike(String value) {
            addCriterion("address like", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotLike(String value) {
            addCriterion("address not like", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressIn(List<String> values) {
            addCriterion("address in", values, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotIn(List<String> values) {
            addCriterion("address not in", values, "address");
            return (Criteria) this;
        }

        public Criteria andAddressBetween(String value1, String value2) {
            addCriterion("address between", value1, value2, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotBetween(String value1, String value2) {
            addCriterion("address not between", value1, value2, "address");
            return (Criteria) this;
        }

        public Criteria andIdCardIsNull() {
            addCriterion("id_card is null");
            return (Criteria) this;
        }

        public Criteria andIdCardIsNotNull() {
            addCriterion("id_card is not null");
            return (Criteria) this;
        }

        public Criteria andIdCardEqualTo(String value) {
            addCriterion("id_card =", value, "idCard");
            return (Criteria) this;
        }

        public Criteria andIdCardNotEqualTo(String value) {
            addCriterion("id_card <>", value, "idCard");
            return (Criteria) this;
        }

        public Criteria andIdCardGreaterThan(String value) {
            addCriterion("id_card >", value, "idCard");
            return (Criteria) this;
        }

        public Criteria andIdCardGreaterThanOrEqualTo(String value) {
            addCriterion("id_card >=", value, "idCard");
            return (Criteria) this;
        }

        public Criteria andIdCardLessThan(String value) {
            addCriterion("id_card <", value, "idCard");
            return (Criteria) this;
        }

        public Criteria andIdCardLessThanOrEqualTo(String value) {
            addCriterion("id_card <=", value, "idCard");
            return (Criteria) this;
        }

        public Criteria andIdCardLike(String value) {
            addCriterion("id_card like", value, "idCard");
            return (Criteria) this;
        }

        public Criteria andIdCardNotLike(String value) {
            addCriterion("id_card not like", value, "idCard");
            return (Criteria) this;
        }

        public Criteria andIdCardIn(List<String> values) {
            addCriterion("id_card in", values, "idCard");
            return (Criteria) this;
        }

        public Criteria andIdCardNotIn(List<String> values) {
            addCriterion("id_card not in", values, "idCard");
            return (Criteria) this;
        }

        public Criteria andIdCardBetween(String value1, String value2) {
            addCriterion("id_card between", value1, value2, "idCard");
            return (Criteria) this;
        }

        public Criteria andIdCardNotBetween(String value1, String value2) {
            addCriterion("id_card not between", value1, value2, "idCard");
            return (Criteria) this;
        }

        public Criteria andFullPhotoIsNull() {
            addCriterion("full_photo is null");
            return (Criteria) this;
        }

        public Criteria andFullPhotoIsNotNull() {
            addCriterion("full_photo is not null");
            return (Criteria) this;
        }

        public Criteria andFullPhotoEqualTo(String value) {
            addCriterion("full_photo =", value, "fullPhoto");
            return (Criteria) this;
        }

        public Criteria andFullPhotoNotEqualTo(String value) {
            addCriterion("full_photo <>", value, "fullPhoto");
            return (Criteria) this;
        }

        public Criteria andFullPhotoGreaterThan(String value) {
            addCriterion("full_photo >", value, "fullPhoto");
            return (Criteria) this;
        }

        public Criteria andFullPhotoGreaterThanOrEqualTo(String value) {
            addCriterion("full_photo >=", value, "fullPhoto");
            return (Criteria) this;
        }

        public Criteria andFullPhotoLessThan(String value) {
            addCriterion("full_photo <", value, "fullPhoto");
            return (Criteria) this;
        }

        public Criteria andFullPhotoLessThanOrEqualTo(String value) {
            addCriterion("full_photo <=", value, "fullPhoto");
            return (Criteria) this;
        }

        public Criteria andFullPhotoLike(String value) {
            addCriterion("full_photo like", value, "fullPhoto");
            return (Criteria) this;
        }

        public Criteria andFullPhotoNotLike(String value) {
            addCriterion("full_photo not like", value, "fullPhoto");
            return (Criteria) this;
        }

        public Criteria andFullPhotoIn(List<String> values) {
            addCriterion("full_photo in", values, "fullPhoto");
            return (Criteria) this;
        }

        public Criteria andFullPhotoNotIn(List<String> values) {
            addCriterion("full_photo not in", values, "fullPhoto");
            return (Criteria) this;
        }

        public Criteria andFullPhotoBetween(String value1, String value2) {
            addCriterion("full_photo between", value1, value2, "fullPhoto");
            return (Criteria) this;
        }

        public Criteria andFullPhotoNotBetween(String value1, String value2) {
            addCriterion("full_photo not between", value1, value2, "fullPhoto");
            return (Criteria) this;
        }

        public Criteria andReversePhotoIsNull() {
            addCriterion("reverse_photo is null");
            return (Criteria) this;
        }

        public Criteria andReversePhotoIsNotNull() {
            addCriterion("reverse_photo is not null");
            return (Criteria) this;
        }

        public Criteria andReversePhotoEqualTo(String value) {
            addCriterion("reverse_photo =", value, "reversePhoto");
            return (Criteria) this;
        }

        public Criteria andReversePhotoNotEqualTo(String value) {
            addCriterion("reverse_photo <>", value, "reversePhoto");
            return (Criteria) this;
        }

        public Criteria andReversePhotoGreaterThan(String value) {
            addCriterion("reverse_photo >", value, "reversePhoto");
            return (Criteria) this;
        }

        public Criteria andReversePhotoGreaterThanOrEqualTo(String value) {
            addCriterion("reverse_photo >=", value, "reversePhoto");
            return (Criteria) this;
        }

        public Criteria andReversePhotoLessThan(String value) {
            addCriterion("reverse_photo <", value, "reversePhoto");
            return (Criteria) this;
        }

        public Criteria andReversePhotoLessThanOrEqualTo(String value) {
            addCriterion("reverse_photo <=", value, "reversePhoto");
            return (Criteria) this;
        }

        public Criteria andReversePhotoLike(String value) {
            addCriterion("reverse_photo like", value, "reversePhoto");
            return (Criteria) this;
        }

        public Criteria andReversePhotoNotLike(String value) {
            addCriterion("reverse_photo not like", value, "reversePhoto");
            return (Criteria) this;
        }

        public Criteria andReversePhotoIn(List<String> values) {
            addCriterion("reverse_photo in", values, "reversePhoto");
            return (Criteria) this;
        }

        public Criteria andReversePhotoNotIn(List<String> values) {
            addCriterion("reverse_photo not in", values, "reversePhoto");
            return (Criteria) this;
        }

        public Criteria andReversePhotoBetween(String value1, String value2) {
            addCriterion("reverse_photo between", value1, value2, "reversePhoto");
            return (Criteria) this;
        }

        public Criteria andReversePhotoNotBetween(String value1, String value2) {
            addCriterion("reverse_photo not between", value1, value2, "reversePhoto");
            return (Criteria) this;
        }

        public Criteria andStatusIsNull() {
            addCriterion("status is null");
            return (Criteria) this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion("status is not null");
            return (Criteria) this;
        }

        public Criteria andStatusEqualTo(Integer value) {
            addCriterion("status =", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualTo(Integer value) {
            addCriterion("status <>", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThan(Integer value) {
            addCriterion("status >", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("status >=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThan(Integer value) {
            addCriterion("status <", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualTo(Integer value) {
            addCriterion("status <=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusIn(List<Integer> values) {
            addCriterion("status in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotIn(List<Integer> values) {
            addCriterion("status not in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusBetween(Integer value1, Integer value2) {
            addCriterion("status between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("status not between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andLoginQtyIsNull() {
            addCriterion("login_qty is null");
            return (Criteria) this;
        }

        public Criteria andLoginQtyIsNotNull() {
            addCriterion("login_qty is not null");
            return (Criteria) this;
        }

        public Criteria andLoginQtyEqualTo(Integer value) {
            addCriterion("login_qty =", value, "loginQty");
            return (Criteria) this;
        }

        public Criteria andLoginQtyNotEqualTo(Integer value) {
            addCriterion("login_qty <>", value, "loginQty");
            return (Criteria) this;
        }

        public Criteria andLoginQtyGreaterThan(Integer value) {
            addCriterion("login_qty >", value, "loginQty");
            return (Criteria) this;
        }

        public Criteria andLoginQtyGreaterThanOrEqualTo(Integer value) {
            addCriterion("login_qty >=", value, "loginQty");
            return (Criteria) this;
        }

        public Criteria andLoginQtyLessThan(Integer value) {
            addCriterion("login_qty <", value, "loginQty");
            return (Criteria) this;
        }

        public Criteria andLoginQtyLessThanOrEqualTo(Integer value) {
            addCriterion("login_qty <=", value, "loginQty");
            return (Criteria) this;
        }

        public Criteria andLoginQtyIn(List<Integer> values) {
            addCriterion("login_qty in", values, "loginQty");
            return (Criteria) this;
        }

        public Criteria andLoginQtyNotIn(List<Integer> values) {
            addCriterion("login_qty not in", values, "loginQty");
            return (Criteria) this;
        }

        public Criteria andLoginQtyBetween(Integer value1, Integer value2) {
            addCriterion("login_qty between", value1, value2, "loginQty");
            return (Criteria) this;
        }

        public Criteria andLoginQtyNotBetween(Integer value1, Integer value2) {
            addCriterion("login_qty not between", value1, value2, "loginQty");
            return (Criteria) this;
        }

        public Criteria andLastLoginIpIsNull() {
            addCriterion("last_login_ip is null");
            return (Criteria) this;
        }

        public Criteria andLastLoginIpIsNotNull() {
            addCriterion("last_login_ip is not null");
            return (Criteria) this;
        }

        public Criteria andLastLoginIpEqualTo(String value) {
            addCriterion("last_login_ip =", value, "lastLoginIp");
            return (Criteria) this;
        }

        public Criteria andLastLoginIpNotEqualTo(String value) {
            addCriterion("last_login_ip <>", value, "lastLoginIp");
            return (Criteria) this;
        }

        public Criteria andLastLoginIpGreaterThan(String value) {
            addCriterion("last_login_ip >", value, "lastLoginIp");
            return (Criteria) this;
        }

        public Criteria andLastLoginIpGreaterThanOrEqualTo(String value) {
            addCriterion("last_login_ip >=", value, "lastLoginIp");
            return (Criteria) this;
        }

        public Criteria andLastLoginIpLessThan(String value) {
            addCriterion("last_login_ip <", value, "lastLoginIp");
            return (Criteria) this;
        }

        public Criteria andLastLoginIpLessThanOrEqualTo(String value) {
            addCriterion("last_login_ip <=", value, "lastLoginIp");
            return (Criteria) this;
        }

        public Criteria andLastLoginIpLike(String value) {
            addCriterion("last_login_ip like", value, "lastLoginIp");
            return (Criteria) this;
        }

        public Criteria andLastLoginIpNotLike(String value) {
            addCriterion("last_login_ip not like", value, "lastLoginIp");
            return (Criteria) this;
        }

        public Criteria andLastLoginIpIn(List<String> values) {
            addCriterion("last_login_ip in", values, "lastLoginIp");
            return (Criteria) this;
        }

        public Criteria andLastLoginIpNotIn(List<String> values) {
            addCriterion("last_login_ip not in", values, "lastLoginIp");
            return (Criteria) this;
        }

        public Criteria andLastLoginIpBetween(String value1, String value2) {
            addCriterion("last_login_ip between", value1, value2, "lastLoginIp");
            return (Criteria) this;
        }

        public Criteria andLastLoginIpNotBetween(String value1, String value2) {
            addCriterion("last_login_ip not between", value1, value2, "lastLoginIp");
            return (Criteria) this;
        }

        public Criteria andLastLoginTimeIsNull() {
            addCriterion("last_login_time is null");
            return (Criteria) this;
        }

        public Criteria andLastLoginTimeIsNotNull() {
            addCriterion("last_login_time is not null");
            return (Criteria) this;
        }

        public Criteria andLastLoginTimeEqualTo(Date value) {
            addCriterion("last_login_time =", value, "lastLoginTime");
            return (Criteria) this;
        }

        public Criteria andLastLoginTimeNotEqualTo(Date value) {
            addCriterion("last_login_time <>", value, "lastLoginTime");
            return (Criteria) this;
        }

        public Criteria andLastLoginTimeGreaterThan(Date value) {
            addCriterion("last_login_time >", value, "lastLoginTime");
            return (Criteria) this;
        }

        public Criteria andLastLoginTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("last_login_time >=", value, "lastLoginTime");
            return (Criteria) this;
        }

        public Criteria andLastLoginTimeLessThan(Date value) {
            addCriterion("last_login_time <", value, "lastLoginTime");
            return (Criteria) this;
        }

        public Criteria andLastLoginTimeLessThanOrEqualTo(Date value) {
            addCriterion("last_login_time <=", value, "lastLoginTime");
            return (Criteria) this;
        }

        public Criteria andLastLoginTimeIn(List<Date> values) {
            addCriterion("last_login_time in", values, "lastLoginTime");
            return (Criteria) this;
        }

        public Criteria andLastLoginTimeNotIn(List<Date> values) {
            addCriterion("last_login_time not in", values, "lastLoginTime");
            return (Criteria) this;
        }

        public Criteria andLastLoginTimeBetween(Date value1, Date value2) {
            addCriterion("last_login_time between", value1, value2, "lastLoginTime");
            return (Criteria) this;
        }

        public Criteria andLastLoginTimeNotBetween(Date value1, Date value2) {
            addCriterion("last_login_time not between", value1, value2, "lastLoginTime");
            return (Criteria) this;
        }

        public Criteria andRegIpIsNull() {
            addCriterion("reg_ip is null");
            return (Criteria) this;
        }

        public Criteria andRegIpIsNotNull() {
            addCriterion("reg_ip is not null");
            return (Criteria) this;
        }

        public Criteria andRegIpEqualTo(String value) {
            addCriterion("reg_ip =", value, "regIp");
            return (Criteria) this;
        }

        public Criteria andRegIpNotEqualTo(String value) {
            addCriterion("reg_ip <>", value, "regIp");
            return (Criteria) this;
        }

        public Criteria andRegIpGreaterThan(String value) {
            addCriterion("reg_ip >", value, "regIp");
            return (Criteria) this;
        }

        public Criteria andRegIpGreaterThanOrEqualTo(String value) {
            addCriterion("reg_ip >=", value, "regIp");
            return (Criteria) this;
        }

        public Criteria andRegIpLessThan(String value) {
            addCriterion("reg_ip <", value, "regIp");
            return (Criteria) this;
        }

        public Criteria andRegIpLessThanOrEqualTo(String value) {
            addCriterion("reg_ip <=", value, "regIp");
            return (Criteria) this;
        }

        public Criteria andRegIpLike(String value) {
            addCriterion("reg_ip like", value, "regIp");
            return (Criteria) this;
        }

        public Criteria andRegIpNotLike(String value) {
            addCriterion("reg_ip not like", value, "regIp");
            return (Criteria) this;
        }

        public Criteria andRegIpIn(List<String> values) {
            addCriterion("reg_ip in", values, "regIp");
            return (Criteria) this;
        }

        public Criteria andRegIpNotIn(List<String> values) {
            addCriterion("reg_ip not in", values, "regIp");
            return (Criteria) this;
        }

        public Criteria andRegIpBetween(String value1, String value2) {
            addCriterion("reg_ip between", value1, value2, "regIp");
            return (Criteria) this;
        }

        public Criteria andRegIpNotBetween(String value1, String value2) {
            addCriterion("reg_ip not between", value1, value2, "regIp");
            return (Criteria) this;
        }

        public Criteria andRegTimeIsNull() {
            addCriterion("reg_time is null");
            return (Criteria) this;
        }

        public Criteria andRegTimeIsNotNull() {
            addCriterion("reg_time is not null");
            return (Criteria) this;
        }

        public Criteria andRegTimeEqualTo(Date value) {
            addCriterion("reg_time =", value, "regTime");
            return (Criteria) this;
        }

        public Criteria andRegTimeNotEqualTo(Date value) {
            addCriterion("reg_time <>", value, "regTime");
            return (Criteria) this;
        }

        public Criteria andRegTimeGreaterThan(Date value) {
            addCriterion("reg_time >", value, "regTime");
            return (Criteria) this;
        }

        public Criteria andRegTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("reg_time >=", value, "regTime");
            return (Criteria) this;
        }

        public Criteria andRegTimeLessThan(Date value) {
            addCriterion("reg_time <", value, "regTime");
            return (Criteria) this;
        }

        public Criteria andRegTimeLessThanOrEqualTo(Date value) {
            addCriterion("reg_time <=", value, "regTime");
            return (Criteria) this;
        }

        public Criteria andRegTimeIn(List<Date> values) {
            addCriterion("reg_time in", values, "regTime");
            return (Criteria) this;
        }

        public Criteria andRegTimeNotIn(List<Date> values) {
            addCriterion("reg_time not in", values, "regTime");
            return (Criteria) this;
        }

        public Criteria andRegTimeBetween(Date value1, Date value2) {
            addCriterion("reg_time between", value1, value2, "regTime");
            return (Criteria) this;
        }

        public Criteria andRegTimeNotBetween(Date value1, Date value2) {
            addCriterion("reg_time not between", value1, value2, "regTime");
            return (Criteria) this;
        }

        public Criteria andUserTypeIsNull() {
            addCriterion("user_type is null");
            return (Criteria) this;
        }

        public Criteria andUserTypeIsNotNull() {
            addCriterion("user_type is not null");
            return (Criteria) this;
        }

        public Criteria andUserTypeEqualTo(Integer value) {
            addCriterion("user_type =", value, "userType");
            return (Criteria) this;
        }

        public Criteria andUserTypeNotEqualTo(Integer value) {
            addCriterion("user_type <>", value, "userType");
            return (Criteria) this;
        }

        public Criteria andUserTypeGreaterThan(Integer value) {
            addCriterion("user_type >", value, "userType");
            return (Criteria) this;
        }

        public Criteria andUserTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("user_type >=", value, "userType");
            return (Criteria) this;
        }

        public Criteria andUserTypeLessThan(Integer value) {
            addCriterion("user_type <", value, "userType");
            return (Criteria) this;
        }

        public Criteria andUserTypeLessThanOrEqualTo(Integer value) {
            addCriterion("user_type <=", value, "userType");
            return (Criteria) this;
        }

        public Criteria andUserTypeIn(List<Integer> values) {
            addCriterion("user_type in", values, "userType");
            return (Criteria) this;
        }

        public Criteria andUserTypeNotIn(List<Integer> values) {
            addCriterion("user_type not in", values, "userType");
            return (Criteria) this;
        }

        public Criteria andUserTypeBetween(Integer value1, Integer value2) {
            addCriterion("user_type between", value1, value2, "userType");
            return (Criteria) this;
        }

        public Criteria andUserTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("user_type not between", value1, value2, "userType");
            return (Criteria) this;
        }

        public Criteria andSiteCodeIsNull() {
            addCriterion("site_code is null");
            return (Criteria) this;
        }

        public Criteria andSiteCodeIsNotNull() {
            addCriterion("site_code is not null");
            return (Criteria) this;
        }

        public Criteria andSiteCodeEqualTo(String value) {
            addCriterion("site_code =", value, "siteCode");
            return (Criteria) this;
        }

        public Criteria andSiteCodeNotEqualTo(String value) {
            addCriterion("site_code <>", value, "siteCode");
            return (Criteria) this;
        }

        public Criteria andSiteCodeGreaterThan(String value) {
            addCriterion("site_code >", value, "siteCode");
            return (Criteria) this;
        }

        public Criteria andSiteCodeGreaterThanOrEqualTo(String value) {
            addCriterion("site_code >=", value, "siteCode");
            return (Criteria) this;
        }

        public Criteria andSiteCodeLessThan(String value) {
            addCriterion("site_code <", value, "siteCode");
            return (Criteria) this;
        }

        public Criteria andSiteCodeLessThanOrEqualTo(String value) {
            addCriterion("site_code <=", value, "siteCode");
            return (Criteria) this;
        }

        public Criteria andSiteCodeLike(String value) {
            addCriterion("site_code like", value, "siteCode");
            return (Criteria) this;
        }

        public Criteria andSiteCodeNotLike(String value) {
            addCriterion("site_code not like", value, "siteCode");
            return (Criteria) this;
        }

        public Criteria andSiteCodeIn(List<String> values) {
            addCriterion("site_code in", values, "siteCode");
            return (Criteria) this;
        }

        public Criteria andSiteCodeNotIn(List<String> values) {
            addCriterion("site_code not in", values, "siteCode");
            return (Criteria) this;
        }

        public Criteria andSiteCodeBetween(String value1, String value2) {
            addCriterion("site_code between", value1, value2, "siteCode");
            return (Criteria) this;
        }

        public Criteria andSiteCodeNotBetween(String value1, String value2) {
            addCriterion("site_code not between", value1, value2, "siteCode");
            return (Criteria) this;
        }

        public Criteria andManagerCodeIsNull() {
            addCriterion("manager_code is null");
            return (Criteria) this;
        }

        public Criteria andManagerCodeIsNotNull() {
            addCriterion("manager_code is not null");
            return (Criteria) this;
        }

        public Criteria andManagerCodeEqualTo(Integer value) {
            addCriterion("manager_code =", value, "managerCode");
            return (Criteria) this;
        }

        public Criteria andManagerCodeNotEqualTo(Integer value) {
            addCriterion("manager_code <>", value, "managerCode");
            return (Criteria) this;
        }

        public Criteria andManagerCodeGreaterThan(Integer value) {
            addCriterion("manager_code >", value, "managerCode");
            return (Criteria) this;
        }

        public Criteria andManagerCodeGreaterThanOrEqualTo(Integer value) {
            addCriterion("manager_code >=", value, "managerCode");
            return (Criteria) this;
        }

        public Criteria andManagerCodeLessThan(Integer value) {
            addCriterion("manager_code <", value, "managerCode");
            return (Criteria) this;
        }

        public Criteria andManagerCodeLessThanOrEqualTo(Integer value) {
            addCriterion("manager_code <=", value, "managerCode");
            return (Criteria) this;
        }

        public Criteria andManagerCodeIn(List<Integer> values) {
            addCriterion("manager_code in", values, "managerCode");
            return (Criteria) this;
        }

        public Criteria andManagerCodeNotIn(List<Integer> values) {
            addCriterion("manager_code not in", values, "managerCode");
            return (Criteria) this;
        }

        public Criteria andManagerCodeBetween(Integer value1, Integer value2) {
            addCriterion("manager_code between", value1, value2, "managerCode");
            return (Criteria) this;
        }

        public Criteria andManagerCodeNotBetween(Integer value1, Integer value2) {
            addCriterion("manager_code not between", value1, value2, "managerCode");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNull() {
            addCriterion("update_time is null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNotNull() {
            addCriterion("update_time is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualTo(Date value) {
            addCriterion("update_time =", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualTo(Date value) {
            addCriterion("update_time <>", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThan(Date value) {
            addCriterion("update_time >", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("update_time >=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThan(Date value) {
            addCriterion("update_time <", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualTo(Date value) {
            addCriterion("update_time <=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIn(List<Date> values) {
            addCriterion("update_time in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotIn(List<Date> values) {
            addCriterion("update_time not in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeBetween(Date value1, Date value2) {
            addCriterion("update_time between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotBetween(Date value1, Date value2) {
            addCriterion("update_time not between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIsNull() {
            addCriterion("update_user is null");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIsNotNull() {
            addCriterion("update_user is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateUserEqualTo(String value) {
            addCriterion("update_user =", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotEqualTo(String value) {
            addCriterion("update_user <>", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThan(String value) {
            addCriterion("update_user >", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThanOrEqualTo(String value) {
            addCriterion("update_user >=", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThan(String value) {
            addCriterion("update_user <", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThanOrEqualTo(String value) {
            addCriterion("update_user <=", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLike(String value) {
            addCriterion("update_user like", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotLike(String value) {
            addCriterion("update_user not like", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIn(List<String> values) {
            addCriterion("update_user in", values, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotIn(List<String> values) {
            addCriterion("update_user not in", values, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserBetween(String value1, String value2) {
            addCriterion("update_user between", value1, value2, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotBetween(String value1, String value2) {
            addCriterion("update_user not between", value1, value2, "updateUser");
            return (Criteria) this;
        }

        public Criteria andRemarksIsNull() {
            addCriterion("remarks is null");
            return (Criteria) this;
        }

        public Criteria andRemarksIsNotNull() {
            addCriterion("remarks is not null");
            return (Criteria) this;
        }

        public Criteria andRemarksEqualTo(String value) {
            addCriterion("remarks =", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksNotEqualTo(String value) {
            addCriterion("remarks <>", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksGreaterThan(String value) {
            addCriterion("remarks >", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksGreaterThanOrEqualTo(String value) {
            addCriterion("remarks >=", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksLessThan(String value) {
            addCriterion("remarks <", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksLessThanOrEqualTo(String value) {
            addCriterion("remarks <=", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksLike(String value) {
            addCriterion("remarks like", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksNotLike(String value) {
            addCriterion("remarks not like", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksIn(List<String> values) {
            addCriterion("remarks in", values, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksNotIn(List<String> values) {
            addCriterion("remarks not in", values, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksBetween(String value1, String value2) {
            addCriterion("remarks between", value1, value2, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksNotBetween(String value1, String value2) {
            addCriterion("remarks not between", value1, value2, "remarks");
            return (Criteria) this;
        }

        public Criteria andLastUserNameIsNull() {
            addCriterion("last_user_name is null");
            return (Criteria) this;
        }

        public Criteria andLastUserNameIsNotNull() {
            addCriterion("last_user_name is not null");
            return (Criteria) this;
        }

        public Criteria andLastUserNameEqualTo(String value) {
            addCriterion("last_user_name =", value, "lastUserName");
            return (Criteria) this;
        }

        public Criteria andLastUserNameNotEqualTo(String value) {
            addCriterion("last_user_name <>", value, "lastUserName");
            return (Criteria) this;
        }

        public Criteria andLastUserNameGreaterThan(String value) {
            addCriterion("last_user_name >", value, "lastUserName");
            return (Criteria) this;
        }

        public Criteria andLastUserNameGreaterThanOrEqualTo(String value) {
            addCriterion("last_user_name >=", value, "lastUserName");
            return (Criteria) this;
        }

        public Criteria andLastUserNameLessThan(String value) {
            addCriterion("last_user_name <", value, "lastUserName");
            return (Criteria) this;
        }

        public Criteria andLastUserNameLessThanOrEqualTo(String value) {
            addCriterion("last_user_name <=", value, "lastUserName");
            return (Criteria) this;
        }

        public Criteria andLastUserNameLike(String value) {
            addCriterion("last_user_name like", value, "lastUserName");
            return (Criteria) this;
        }

        public Criteria andLastUserNameNotLike(String value) {
            addCriterion("last_user_name not like", value, "lastUserName");
            return (Criteria) this;
        }

        public Criteria andLastUserNameIn(List<String> values) {
            addCriterion("last_user_name in", values, "lastUserName");
            return (Criteria) this;
        }

        public Criteria andLastUserNameNotIn(List<String> values) {
            addCriterion("last_user_name not in", values, "lastUserName");
            return (Criteria) this;
        }

        public Criteria andLastUserNameBetween(String value1, String value2) {
            addCriterion("last_user_name between", value1, value2, "lastUserName");
            return (Criteria) this;
        }

        public Criteria andLastUserNameNotBetween(String value1, String value2) {
            addCriterion("last_user_name not between", value1, value2, "lastUserName");
            return (Criteria) this;
        }

        public Criteria andParentUserNameIsNull() {
            addCriterion("parent_user_name is null");
            return (Criteria) this;
        }

        public Criteria andParentUserNameIsNotNull() {
            addCriterion("parent_user_name is not null");
            return (Criteria) this;
        }

        public Criteria andParentUserNameEqualTo(String value) {
            addCriterion("parent_user_name =", value, "parentUserName");
            return (Criteria) this;
        }

        public Criteria andParentUserNameNotEqualTo(String value) {
            addCriterion("parent_user_name <>", value, "parentUserName");
            return (Criteria) this;
        }

        public Criteria andParentUserNameGreaterThan(String value) {
            addCriterion("parent_user_name >", value, "parentUserName");
            return (Criteria) this;
        }

        public Criteria andParentUserNameGreaterThanOrEqualTo(String value) {
            addCriterion("parent_user_name >=", value, "parentUserName");
            return (Criteria) this;
        }

        public Criteria andParentUserNameLessThan(String value) {
            addCriterion("parent_user_name <", value, "parentUserName");
            return (Criteria) this;
        }

        public Criteria andParentUserNameLessThanOrEqualTo(String value) {
            addCriterion("parent_user_name <=", value, "parentUserName");
            return (Criteria) this;
        }

        public Criteria andParentUserNameLike(String value) {
            addCriterion("parent_user_name like", value, "parentUserName");
            return (Criteria) this;
        }

        public Criteria andParentUserNameNotLike(String value) {
            addCriterion("parent_user_name not like", value, "parentUserName");
            return (Criteria) this;
        }

        public Criteria andParentUserNameIn(List<String> values) {
            addCriterion("parent_user_name in", values, "parentUserName");
            return (Criteria) this;
        }

        public Criteria andParentUserNameNotIn(List<String> values) {
            addCriterion("parent_user_name not in", values, "parentUserName");
            return (Criteria) this;
        }

        public Criteria andParentUserNameBetween(String value1, String value2) {
            addCriterion("parent_user_name between", value1, value2, "parentUserName");
            return (Criteria) this;
        }

        public Criteria andParentUserNameNotBetween(String value1, String value2) {
            addCriterion("parent_user_name not between", value1, value2, "parentUserName");
            return (Criteria) this;
        }

        public Criteria andDeductionUserNameIsNull() {
            addCriterion("deduction_user_name is null");
            return (Criteria) this;
        }

        public Criteria andDeductionUserNameIsNotNull() {
            addCriterion("deduction_user_name is not null");
            return (Criteria) this;
        }

        public Criteria andDeductionUserNameEqualTo(String value) {
            addCriterion("deduction_user_name =", value, "deductionUserName");
            return (Criteria) this;
        }

        public Criteria andDeductionUserNameNotEqualTo(String value) {
            addCriterion("deduction_user_name <>", value, "deductionUserName");
            return (Criteria) this;
        }

        public Criteria andDeductionUserNameGreaterThan(String value) {
            addCriterion("deduction_user_name >", value, "deductionUserName");
            return (Criteria) this;
        }

        public Criteria andDeductionUserNameGreaterThanOrEqualTo(String value) {
            addCriterion("deduction_user_name >=", value, "deductionUserName");
            return (Criteria) this;
        }

        public Criteria andDeductionUserNameLessThan(String value) {
            addCriterion("deduction_user_name <", value, "deductionUserName");
            return (Criteria) this;
        }

        public Criteria andDeductionUserNameLessThanOrEqualTo(String value) {
            addCriterion("deduction_user_name <=", value, "deductionUserName");
            return (Criteria) this;
        }

        public Criteria andDeductionUserNameLike(String value) {
            addCriterion("deduction_user_name like", value, "deductionUserName");
            return (Criteria) this;
        }

        public Criteria andDeductionUserNameNotLike(String value) {
            addCriterion("deduction_user_name not like", value, "deductionUserName");
            return (Criteria) this;
        }

        public Criteria andDeductionUserNameIn(List<String> values) {
            addCriterion("deduction_user_name in", values, "deductionUserName");
            return (Criteria) this;
        }

        public Criteria andDeductionUserNameNotIn(List<String> values) {
            addCriterion("deduction_user_name not in", values, "deductionUserName");
            return (Criteria) this;
        }

        public Criteria andDeductionUserNameBetween(String value1, String value2) {
            addCriterion("deduction_user_name between", value1, value2, "deductionUserName");
            return (Criteria) this;
        }

        public Criteria andDeductionUserNameNotBetween(String value1, String value2) {
            addCriterion("deduction_user_name not between", value1, value2, "deductionUserName");
            return (Criteria) this;
        }

        public Criteria andAssociatefirstlevelUserNameIsNull() {
            addCriterion("associateFirstLevel_user_name is null");
            return (Criteria) this;
        }

        public Criteria andAssociatefirstlevelUserNameIsNotNull() {
            addCriterion("associateFirstLevel_user_name is not null");
            return (Criteria) this;
        }

        public Criteria andAssociatefirstlevelUserNameEqualTo(String value) {
            addCriterion("associateFirstLevel_user_name =", value, "associatefirstlevelUserName");
            return (Criteria) this;
        }

        public Criteria andAssociatefirstlevelUserNameNotEqualTo(String value) {
            addCriterion("associateFirstLevel_user_name <>", value, "associatefirstlevelUserName");
            return (Criteria) this;
        }

        public Criteria andAssociatefirstlevelUserNameGreaterThan(String value) {
            addCriterion("associateFirstLevel_user_name >", value, "associatefirstlevelUserName");
            return (Criteria) this;
        }

        public Criteria andAssociatefirstlevelUserNameGreaterThanOrEqualTo(String value) {
            addCriterion("associateFirstLevel_user_name >=", value, "associatefirstlevelUserName");
            return (Criteria) this;
        }

        public Criteria andAssociatefirstlevelUserNameLessThan(String value) {
            addCriterion("associateFirstLevel_user_name <", value, "associatefirstlevelUserName");
            return (Criteria) this;
        }

        public Criteria andAssociatefirstlevelUserNameLessThanOrEqualTo(String value) {
            addCriterion("associateFirstLevel_user_name <=", value, "associatefirstlevelUserName");
            return (Criteria) this;
        }

        public Criteria andAssociatefirstlevelUserNameLike(String value) {
            addCriterion("associateFirstLevel_user_name like", value, "associatefirstlevelUserName");
            return (Criteria) this;
        }

        public Criteria andAssociatefirstlevelUserNameNotLike(String value) {
            addCriterion("associateFirstLevel_user_name not like", value, "associatefirstlevelUserName");
            return (Criteria) this;
        }

        public Criteria andAssociatefirstlevelUserNameIn(List<String> values) {
            addCriterion("associateFirstLevel_user_name in", values, "associatefirstlevelUserName");
            return (Criteria) this;
        }

        public Criteria andAssociatefirstlevelUserNameNotIn(List<String> values) {
            addCriterion("associateFirstLevel_user_name not in", values, "associatefirstlevelUserName");
            return (Criteria) this;
        }

        public Criteria andAssociatefirstlevelUserNameBetween(String value1, String value2) {
            addCriterion("associateFirstLevel_user_name between", value1, value2, "associatefirstlevelUserName");
            return (Criteria) this;
        }

        public Criteria andAssociatefirstlevelUserNameNotBetween(String value1, String value2) {
            addCriterion("associateFirstLevel_user_name not between", value1, value2, "associatefirstlevelUserName");
            return (Criteria) this;
        }

        public Criteria andLookProdClassIsNull() {
            addCriterion("look_prod_class is null");
            return (Criteria) this;
        }

        public Criteria andLookProdClassIsNotNull() {
            addCriterion("look_prod_class is not null");
            return (Criteria) this;
        }

        public Criteria andLookProdClassEqualTo(String value) {
            addCriterion("look_prod_class =", value, "lookProdClass");
            return (Criteria) this;
        }

        public Criteria andLookProdClassNotEqualTo(String value) {
            addCriterion("look_prod_class <>", value, "lookProdClass");
            return (Criteria) this;
        }

        public Criteria andLookProdClassGreaterThan(String value) {
            addCriterion("look_prod_class >", value, "lookProdClass");
            return (Criteria) this;
        }

        public Criteria andLookProdClassGreaterThanOrEqualTo(String value) {
            addCriterion("look_prod_class >=", value, "lookProdClass");
            return (Criteria) this;
        }

        public Criteria andLookProdClassLessThan(String value) {
            addCriterion("look_prod_class <", value, "lookProdClass");
            return (Criteria) this;
        }

        public Criteria andLookProdClassLessThanOrEqualTo(String value) {
            addCriterion("look_prod_class <=", value, "lookProdClass");
            return (Criteria) this;
        }

        public Criteria andLookProdClassLike(String value) {
            addCriterion("look_prod_class like", value, "lookProdClass");
            return (Criteria) this;
        }

        public Criteria andLookProdClassNotLike(String value) {
            addCriterion("look_prod_class not like", value, "lookProdClass");
            return (Criteria) this;
        }

        public Criteria andLookProdClassIn(List<String> values) {
            addCriterion("look_prod_class in", values, "lookProdClass");
            return (Criteria) this;
        }

        public Criteria andLookProdClassNotIn(List<String> values) {
            addCriterion("look_prod_class not in", values, "lookProdClass");
            return (Criteria) this;
        }

        public Criteria andLookProdClassBetween(String value1, String value2) {
            addCriterion("look_prod_class between", value1, value2, "lookProdClass");
            return (Criteria) this;
        }

        public Criteria andLookProdClassNotBetween(String value1, String value2) {
            addCriterion("look_prod_class not between", value1, value2, "lookProdClass");
            return (Criteria) this;
        }

        public Criteria andLookAddressIsNull() {
            addCriterion("look_address is null");
            return (Criteria) this;
        }

        public Criteria andLookAddressIsNotNull() {
            addCriterion("look_address is not null");
            return (Criteria) this;
        }

        public Criteria andLookAddressEqualTo(String value) {
            addCriterion("look_address =", value, "lookAddress");
            return (Criteria) this;
        }

        public Criteria andLookAddressNotEqualTo(String value) {
            addCriterion("look_address <>", value, "lookAddress");
            return (Criteria) this;
        }

        public Criteria andLookAddressGreaterThan(String value) {
            addCriterion("look_address >", value, "lookAddress");
            return (Criteria) this;
        }

        public Criteria andLookAddressGreaterThanOrEqualTo(String value) {
            addCriterion("look_address >=", value, "lookAddress");
            return (Criteria) this;
        }

        public Criteria andLookAddressLessThan(String value) {
            addCriterion("look_address <", value, "lookAddress");
            return (Criteria) this;
        }

        public Criteria andLookAddressLessThanOrEqualTo(String value) {
            addCriterion("look_address <=", value, "lookAddress");
            return (Criteria) this;
        }

        public Criteria andLookAddressLike(String value) {
            addCriterion("look_address like", value, "lookAddress");
            return (Criteria) this;
        }

        public Criteria andLookAddressNotLike(String value) {
            addCriterion("look_address not like", value, "lookAddress");
            return (Criteria) this;
        }

        public Criteria andLookAddressIn(List<String> values) {
            addCriterion("look_address in", values, "lookAddress");
            return (Criteria) this;
        }

        public Criteria andLookAddressNotIn(List<String> values) {
            addCriterion("look_address not in", values, "lookAddress");
            return (Criteria) this;
        }

        public Criteria andLookAddressBetween(String value1, String value2) {
            addCriterion("look_address between", value1, value2, "lookAddress");
            return (Criteria) this;
        }

        public Criteria andLookAddressNotBetween(String value1, String value2) {
            addCriterion("look_address not between", value1, value2, "lookAddress");
            return (Criteria) this;
        }

        public Criteria andShippineTypeIsNull() {
            addCriterion("shippine_type is null");
            return (Criteria) this;
        }

        public Criteria andShippineTypeIsNotNull() {
            addCriterion("shippine_type is not null");
            return (Criteria) this;
        }

        public Criteria andShippineTypeEqualTo(String value) {
            addCriterion("shippine_type =", value, "shippineType");
            return (Criteria) this;
        }

        public Criteria andShippineTypeNotEqualTo(String value) {
            addCriterion("shippine_type <>", value, "shippineType");
            return (Criteria) this;
        }

        public Criteria andShippineTypeGreaterThan(String value) {
            addCriterion("shippine_type >", value, "shippineType");
            return (Criteria) this;
        }

        public Criteria andShippineTypeGreaterThanOrEqualTo(String value) {
            addCriterion("shippine_type >=", value, "shippineType");
            return (Criteria) this;
        }

        public Criteria andShippineTypeLessThan(String value) {
            addCriterion("shippine_type <", value, "shippineType");
            return (Criteria) this;
        }

        public Criteria andShippineTypeLessThanOrEqualTo(String value) {
            addCriterion("shippine_type <=", value, "shippineType");
            return (Criteria) this;
        }

        public Criteria andShippineTypeLike(String value) {
            addCriterion("shippine_type like", value, "shippineType");
            return (Criteria) this;
        }

        public Criteria andShippineTypeNotLike(String value) {
            addCriterion("shippine_type not like", value, "shippineType");
            return (Criteria) this;
        }

        public Criteria andShippineTypeIn(List<String> values) {
            addCriterion("shippine_type in", values, "shippineType");
            return (Criteria) this;
        }

        public Criteria andShippineTypeNotIn(List<String> values) {
            addCriterion("shippine_type not in", values, "shippineType");
            return (Criteria) this;
        }

        public Criteria andShippineTypeBetween(String value1, String value2) {
            addCriterion("shippine_type between", value1, value2, "shippineType");
            return (Criteria) this;
        }

        public Criteria andShippineTypeNotBetween(String value1, String value2) {
            addCriterion("shippine_type not between", value1, value2, "shippineType");
            return (Criteria) this;
        }
    }

    /**
     * m_user_base
     */
    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    /**
     * @title m_user_base表的实体类
     * @description m_user_base
     * @version 1.0
     * @author may
     * @date 2021-04-23 14:23:00
     */
    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}
